<?php 
require_once('system/dbConn.php');
connect();
//获取视频类别列表
$sql_vt="select * from videotype";
$vt_list=fetch_array($sql_vt);
//获取点击排行列表
$sql_hits="select * from videos oreder by hittimes desc limit 0,4";
$hits_list=fetch_array($sql_hits);
//获取视频信息
$v_list=array();
foreach($vt_list as $one){
	$sql="select * from videos where tid=".$one['tid']."  order by vid desc limit 0,6";
	$vlist=array();
	$vlist['tid']=$one['tid'];
	$vlist['typename']=$one['typename'];
	$vlist['list']=fetch_array($sql);
	$v_list[]=$vlist;
}
?>
<!DOCTYPE html>
<html lang="zh-cn">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">
    <meta name="author" content="">
    <link rel="icon" href="../../favicon.ico">

    <title>Off Canvas Template for Bootstrap</title>

    <!-- Bootstrap core CSS -->
    <link href="assets/css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom styles for this template -->
    <link href="assets/css/offcanvas.css" rel="stylesheet">
    <link href="assets/css/style.css" rel="stylesheet">
    <!-- Just for debugging purposes. Don't actually copy these 2 lines! -->
    <!--[if lt IE 9]>
    <script src="assets/js/ie8-responsive-file-warning.js"></script><![endif]-->
    <script src="assets/js/ie-emulation-modes-warning.js"></script>

    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
    <script src="http://cdn.bootcss.com/html5shiv/3.7.2/html5shiv.min.js"></script>
    <script src="http://cdn.bootcss.com/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->
</head>

<body>
<nav class="navbar navbar-fixed-top navbar-inverse">
  <div class="container-fluid">
    <!-- Brand and toggle get grouped for better mobile display -->
    <div class="navbar-header">
      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
        <span class="sr-only">Toggle navigation</span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
      </button>
     
    </div>

    <!-- Collect the nav links, forms, and other content for toggling -->
    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
      <ul class="nav navbar-nav">
        <li><a href="#">首页 <span class="sr-only">(current)</span></a></li>
         <?php 
         foreach ($vt_list as $one) {
            echo'<li><a href="list.php?id='.$one['tid'].'">'.$one['typename'].'</a></li>';
         }

 ?>
        <!-- <li><a href="list.html">电影</a></li>
        <li><a href="list.html">电视剧</a></li>
        <li><a href="list.html">动画片</a></li>
        <li><a href="list.html">体育</a></li>
        <li class="dropdown">
          <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">原创 <span class="caret"></span></a>
          <ul class="dropdown-menu">
            <li><a href="#">喜剧</a></li>
            <li><a href="#">科幻</a></li>
            <li><a href="#">教育</a></li>
            <li role="separator" class="divider"></li>
            <li><a href="#">其他</a></li>
          
          </ul>
        </li> -->
      </ul>
      <form class="navbar-form navbar-left" role="search" action="search.html">
        <div class="form-group">
          <input type="text" class="form-control" placeholder="Search">
        </div>
        <button type="submit" class="btn btn-default">搜索</button>
      </form>
      <ul class="nav navbar-nav navbar-right">
        <li><a href="#" data-toggle="modal" data-target="#myModal1">登录</a></li>
        <li><a href="reg.php" >注册</a></li>
      
      </ul>
    </div><!-- /.navbar-collapse -->
  </div><!-- /.container-fluid -->
</nav>

<!-- /.navbar -->


<div class="container">
<!--幻灯片开始-->
<div id="carousel-example-generic" class="carousel slide" data-ride="carousel">
    <!-- Indicators -->
    <ol class="carousel-indicators">
        <li data-target="#carousel-example-generic" data-slide-to="0" class="active"></li>
        <li data-target="#carousel-example-generic" data-slide-to="1"></li>
        <li data-target="#carousel-example-generic" data-slide-to="2"></li>
    </ol>

    <!-- Wrapper for slides -->
    <div class="carousel-inner">
        <div class="item active">
            <img src="assets/images/img4.jpg" class="img-responsive" alt="Apple iPhone 5S">

            <div class="carousel-caption">
                <h3>Apple iPhone 5S</h3>

            </div>
        </div>
        <div class="item">
            <img src="assets/images/img2.jpg" class="img-responsive" alt="Samsung Galaxy Note 3">

            <div class="carousel-caption">
                <h3>Samsung Galaxy Note 3</h3>

            </div>
        </div>
        <div class="item">
            <img src="assets/images/img3.jpg" class="img-responsive" alt="Apple iPhone 5S">

            <div class="carousel-caption">
                <h3>Sony Xperia Z1</h3>

            </div>
        </div>
    </div>

    <!-- Controls -->
    <a class="left carousel-control" href="#carousel-example-generic" data-slide="prev">
        <span class="glyphicon glyphicon-chevron-left"></span>
    </a>
    <a class="right carousel-control" href="#carousel-example-generic" data-slide="next">
        <span class="glyphicon glyphicon-chevron-right"></span>
    </a>
</div>
<!--幻灯片结束-->



    <div class="row row-offcanvas row-offcanvas-right">

        <div class="col-xs-12 col-sm-9">


            <div class="row text-center">
            <?php 
            foreach ($v_list as $vt ) {
            	?>
            	<div class="col-xs-12 col-lg-12 mlist">
                    <h2><?php echo $vt['typename'];?></h2>
                    <ul class="list-inline row text-center">
                    <?php 
                    foreach($vt['list'] as $one){
                    	echo'<li class="col-xs-6 col-sm-4 col-md-2">
                      <img src="assets/images/'.$one['pic'].'" class="responsive img-thumbnail"/>
                      <p><a href="show.html">'.$one['videoname'].'</a>
                      </p>
                  </li>
                  <li class="col-xs-12 col-lg-6">
                      <img src="assets/images/img1.jpg" class="responsive img-thumbnail"/>
                  
                      <p><a href="show.php?id='.$one['vid'].'">'.$one['videoname'].'</a>
                      </p>
                  </li> ';
                    }

                     ?>







                        <li class="col-xs-4 col-sm-3 col-lg-2">
                            <img src="assets/images/img1.jpg" class="responsive img-thumbnail"/>
                
                            <p><a href="show.html">视频标题</a>
                            </p>
                        </li>
                        <li class="col-xs-4 col-sm-3 col-lg-2">
                            <img src="assets/images/img1.jpg" class="responsive img-thumbnail"/>
                
                            <p><a href="show.html">视频标题</a>
                            </p>
                        </li>
                
                    </ul>
                    <p><a class="btn btn-default" href="list.php?id=<?php echo$vt['tid'] ?>" role="button">更多 &raquo;</a></p>
                </div>

            	<?php 
            }

             ?>
                <!-- <div class="col-xs-12 col-lg-12 mlist">
                    <h2>栏目名称</h2>
                    <ul class="list-inline row text-center">
                        <li class="col-xs-4 col-sm-3 col-lg-2">
                            <img src="assets/images/img1.jpg" class="responsive img-thumbnail"/>
                
                            <p><a href="show.html">视频标题</a>
                            </p>
                        </li>
                        <li class="col-xs-4 col-sm-3 col-lg-2">
                            <img src="assets/images/img1.jpg" class="responsive img-thumbnail"/>
                
                            <p><a href="show.html">视频标题</a>
                            </p>
                        </li>
                
                    </ul>
                    <p><a class="btn btn-default" href="list.html" role="button">更多 &raquo;</a></p>
                </div> -->
                <!--/.col-xs-6.col-lg-4-->

            </div>
            <!--/row-->
        </div>
        <!--/.col-xs-12.col-sm-9-->

        <div class="col-xs-6 col-sm-3 sidebar-offcanvas" id="sidebar">
            <div class="list-group text-center">
                <h2 style="color:white;" >排行</h2>
                <ul class="list-inline row text-center">
                <?php 
                foreach($hits_list as $one){
                	echo'<li class="col-xs-12 col-lg-6">
                      <img src="assets/images/'.$one['pic'].'" class="responsive img-thumbnail"/>
                      <p><a href="show.html">'.$one['videoname'].'</a>
                      </p>
                  </li>
                  <li class="col-xs-12 col-lg-6">
                      <img src="assets/images/img1.jpg" class="responsive img-thumbnail"/>
                  
                      <p><a href="show.php?id='.$one['vid'].'">'.$one['videoname'].'</a>
                      </p>
                  </li> ';

                }
                   
                   ?>
                  <!--   <li class="col-xs-12 col-lg-6">
                      <img src="assets/images/img1.jpg" class="responsive img-thumbnail"/>
                  
                      <p><a href="show.html">视频标题</a>
                      </p>
                  </li>
                  <li class="col-xs-12 col-lg-6">
                      <img src="assets/images/img1.jpg" class="responsive img-thumbnail"/>
                  
                      <p><a href="show.html">视频标题</a>
                      </p>
                  </li> -->

                </ul>
            </div>

        </div>
        <!--/.sidebar-offcanvas-->
    </div>
    <!--/row-->

   

</div>
<!--/.container-->
 <hr>

    <footer>
        <p>&copy; Company 2014</p>
    </footer>

<!-- Bootstrap core JavaScript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>

<!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
<script src="assets/js/ie10-viewport-bug-workaround.js"></script>

<script src="offcanvas.js"></script>
<script>
    $('.carousel').carousel({
        interval: 3000 //changes the speed
    })
</script>
</body>
</html>
